package utility;

public class SQL {
	public static final String DDL_TYPE_CREATE							= "CREATE";
	public static final String DDL_TYPE_ALTER							= "ALTER";
	public static final String DDL_TYPE_DROP							= "DROP";
	
	public static final String DML_TYPE_SELECT							= "SELECT";
	public static final String DML_TYPE_INSERT							= "INSERT";
	public static final String DML_TYPE_UPDATE							= "UPDATE";
	public static final String DML_TYPE_DELETE							= "DELETE";
	
	public static final String TOKEN_TABLE								= "TABLE";
	public static final String TOKEN_COLUMN								= "COLUMN";
	public static final String TOKEN_FROM								= "FROM";
	public static final String TOKEN_WHERE								= "WHERE";
	public static final String TOKEN_ORDERBY							= "ORDERBY";
	public static final String TOKEN_INTO								= "INTO";
	public static final String TOKEN_VALUES								= "VALUES";
	public static final String TOKEN_PRIMARYKEY							= "PRIMARYKEY";
	public static final String TOKEN_UNIQUE								= "UNIQUE";
	public static final String TOKEN_FOREIGNKEY							= "FOREIGNKEY";
	public static final String TOKEN_SET								= "SET";
	public static final String TOKEN_NAME								= "NAME";
	
	public static final String TOKEN_VALUE_GROUP_OPEN					= "(";
	public static final String TOKEN_VALUE_GROUP_SEPARATOR				= ",";
	public static final String TOKEN_VALUE_GROUP_CLOSE					= ")";
	
	public static final String TOKEN_VALUE_STRING_CHAR					= "\"";
	public static final String TOKEN_VALUE_BOOLEAN_TRUE					= "TRUE";
	public static final String TOKEN_VALUE_BOOLEAN_FALSE				= "FALSE";
	public static final String TOKEN_VALUE_NULL							= "NULL";
	
	public static final String ORDERBY_DIRECTION_DEFAULT 				= "ASC"; 
	
	public static final String WHERE_CLAUSE_OPERATOR_OR 				= "OR"; 
	public static final String WHERE_CLAUSE_OPERATOR_AND	 			= "AND"; 
	
	public static final String EXPRESSION_OPERATOR_EQUALTO				= "="; 
	public static final String EXPRESSION_OPERATOR_NOT_EQUALTO			= "!="; 
	public static final String EXPRESSION_OPERATOR_BIGGERTHAN 			= ">"; 
	public static final String EXPRESSION_OPERATOR_SMALLERTHAN 			= "<"; 
	public static final String EXPRESSION_OPERATOR_BIGGERTHANOREQUAL 	= ">="; 
	public static final String EXPRESSION_OPERATOR_SMALLERTHANOREQUAL 	= "<="; 
	
	public static final String DATATYPE_INT 							= "INT";
	public static final String DATATYPE_STRING 							= "STR";
	public static final String DATATYPE_BOOLEAN							= "BLN";
	
	public static final String DEFAULT_VALUE_INT						= "0";
	public static final String DEFAULT_VALUE_STR						= "";
	public static final String DEFAULT_VALUE_BLN						= TOKEN_VALUE_BOOLEAN_FALSE;
}
